<?php

namespace App\Http\Controllers\Admin;

use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use App\Model\Cat;
use DB;

class CatController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
       
        $cats = $this->findAll();

        return view('admin.cat_index')->with('cats',$cats);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        $cats = $this->findAll();
        return view('admin.cat_add')->with('cats',$cats);
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $cat['name'] = $request->name;
        $cat['pid'] = $request->pid;
        DB::table('cats')->insert($cat);
        return redirect('admin/cat');
        
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
       

    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {

         $cat = DB::table('cats')->where('id',$id)->first();
         $data = $cat->pid;
        
         if($data > 0){
            $pid = $cat->pid;
         $parent_cat = DB::table('cats')->where('id',$pid)->first();
         $parent_name = $parent_cat->name;
         }else{
            $parent_name = '顶级栏目';
         }
         
        

       
         

         return view('admin.cat_edit',['cat'=>$cat,'parent_name'=>$parent_name]);
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        DB::table('cats')->where('id',$id)->update(['name'=>$request->name]);
        return redirect('admin/cat');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        Cat::destroy($id);
        return redirect('/admin/cat');

    }


    /**
     * 封装一个显示层级的小方法
     */
    protected function findTree($data,$id=0,$lev=0)
    {
        static $tree=[];
        foreach($data as $k=>$v){
            if($v->pid == $id){
                $v->lev = $lev;
                $tree[] = $v;
                $this->findTree($data,$v->id,$lev+1); 
            }
        }
        return $tree;
    }
    protected function findAll()
    {
        $data = Cat::all();
        return $this->findTree($data,0,0);
    }
}
